Redesign WATCHES.Type to be A-Rec, B-Rec, Location, and Other
authorKarl O. Pinc kop@karlpinc.com <kop@karlpinc.com>
Tue, 14 Jul 2026 22:55:09 +0000 (22:55 +0000)
committerKarl O. Pinc kop@karlpinc.com <kop@karlpinc.com>
Tue, 14 Jul 2026 22:55:09 +0000 (22:55 +0000)
commit1cc9e694a1f6a53c396d9074f77d5d279018721b
tree4644524290a489002f8aff06bfd4a20f9dfaac4a
parent5e4f6469f748aac861efad7dd79cd7bfdb70614b
Redesign WATCHES.Type to be A-Rec, B-Rec, Location, and Other

Instead of having a different WATCHES.Type for each behavior that does
not have a corresponding follow record, and different types for
feeding station arrivals and feeding station groom scans, have only 2
types.  One for A records and one for B records.  There are also types
for locations and for "other", the latter of which is equalivant to a
B-Record.  Presumeably "other" is used for grad-student data, etc.
17 files changed:
conversion/load_aggressions.m4
conversion/load_follow_arrival.m4
conversion/load_follow_to_watches.sql
db/schemas/lib/triggers/create/events.m4
db/schemas/lib/triggers/create/follow_observers.m4
db/schemas/lib/triggers/create/pantgrunts_view.m4
db/schemas/lib/triggers/create/roles.m4
db/schemas/lib/triggers/create/watches.m4
db/schemas/lib/triggers/drop/events.m4
db/schemas/sokwedb/indexes/create/watches.m4
db/schemas/sokwedb/indexes/drop/watches.m4
db/schemas/sokwedb/tables/create/watches.m4
doc/src/epilog.inc.m4
doc/src/tables/events.m4
doc/src/tables/follow_observers.m4
doc/src/tables/watches.m4
include/global_constants.m4